Profile Rule Export Tool Integration

The Profile Rule Export tool allows users to export the syntax or definition of a segment document created in Campaign Manager, based on web analytics data, to Kettle.

The Profile Rule Export tool generates the rules in a .ktr file (Kettle Transformation file), based on a template previously uploaded to the document store, allowing the export of the rules for triggering inside a Kettle job. Query element nodes in Campaign Manager are translated to FilterRow steps in the .ktr file.

To use this tool, a .ktr file must first be created. The file can contain any number of steps, however one step must be a dummy step named 'Template'. For example:

Save the Template .ktr file, and upload to the Campaign Manager document store.

When the Profile Rule Export Tool is used, the following ktr output is generated. The logic step contains the Profile Rule information from Campaign Manager:

• Integrations between Campaign Manager and Kettle
  • External Integrations Pack
  • Terminology Used in Integrations
  • File Tactic Integration
  • Omni Tactic Integration
  • Profile Rule Export Tool Integration
  • Injecting a Custom Transformation Into an Output Tactic
  • Data Input and Integration Points
  • Creating a Kettle script
  • Using a Kettle Job in Campaign Manager
  • Example code